Excel Shortcuts List for Mac and PC (Searchable)
How to Use this Shortcut List:
+ Indicates to hold the previous key, while pressing the next key.
> Indicates to tap the previous key, releasing it before pressing the next key.
Find the shortcuts list below:
| Description | PC Shortcut | Mac Shortcut |
|---|---|---|
| Basic Shortcuts | yes | |
| Save Workbook | Ctrl+S | ⌘+S |
| Save As | F12 | ⌘+⇧+S |
Ctrl+P | ⌘+P |
|
| Create New Workbook | Ctrl+N | ⌘+N |
| Open Workbook | Ctrl+O | ⌘+O |
| Open Print Preview | Ctrl+F2 | ⌘+P |
| Close Workbook | Ctrl+F4 | ⌘+W |
| Close Excel | Alt+F4 | ⌘+Q |
| Undo Previous Action | Ctrl+Z | ⌘+Z |
| Redo Previous Action | Ctrl+Y | ⌘+Y |
| Open Help | F1 | ⌘+/ |
| Clear Cell Contents | Delete | fn+delete |
| Clear Cell Formatting | Alt > H > E > F | |
| Clear All | Alt > H > E > A | |
| Number Formatting Shortcuts | yes | |
| Apply General Format | Ctrl+Shift+~ | ⌃+⇧+~ |
| Apply Number Format | Ctrl+Shift+! | ⌃+⇧+! |
| Apply Time Format | Ctrl+Shift+@ | ⌃+⇧+@ |
| Apply Date Format | Ctrl+Shift+# | ⌃+⇧+# |
| Apply Currency Format | Ctrl+Shift+$ | ⌃+⇧+$ |
| Apply Percentage Format | Ctrl+Shift+% | ⌃+⇧+% |
| Apply Scientific Format | Ctrl+Shift+^ | ⌃+⇧+^ |
| Viewing Shortcuts | yes | |
| Close Window | Ctrl+WorCtrl+F4 | ⌘+W |
| Restore Window Size | Ctrl+F5 | |
| Next Window | Ctrl+F6 | |
| Move Window | Ctrl+F7 | |
| Resize Window | Ctrl+F8 | |
| Minimize Window | Ctrl+F9 | ⌃+F9 |
| Maximize / Restore Window | Ctrl+F10 | ⌘+F10 |
| Next Pane | F6 | |
| Previous Pane | Shift+F6 | |
| Full Screen Mode | Alt > V > U | ⌘+⌃+F |
| Exit Full Screen | Esc | esc |
| Rotate or Flip Screen | Ctrl+Alt+↓ | |
| Take Screenshot | PrtSc | ⌘+⇧+3 |
| View Mode Shortcuts | yes | |
| Toggle Formula View Mode | Ctrl+` | ⌃+` |
| Open Print Preview | Ctrl+F2 | ⌘+P |
| Expand Or Collapse Ribbon | Ctrl+F1 | ⌘+⌥+R |
| Expand Or Collapse The Formula Bar | Ctrl+Shift+U | ⌃+⇧+U |
| Copy, Cut, & Paste Shortcuts | yes | |
| Copy | Ctrl+C | ⌘+C |
| Cut | Ctrl+X | ⌘+X |
| Paste | Ctrl+V | ⌘+V |
| Open Paste Special Dialog Box | Ctrl+Alt+V | ⌃+⌘+V |
| Paste Value | Ctrl+Alt+V > V > Enter | ⌃+⌘+V > ⌘+V > return |
| Paste Format | Ctrl+Alt+V > T > Enter | ⌃+⌘+V > ⌘+T > return |
| Paste & Transpose | Ctrl+Alt+V > E > Enter | ⌃+⌘+V > ⌘+E > return |
| Paste & Skip Blanks | Ctrl+Alt+V > B > Enter | ⌃+⌘+V > ⌘+B > return |
| Borders Shortcuts | yes | |
| Add Outline Border | Ctrl+Shift+& | ⌘+⌥+0 |
| Add Or Remove Top Border | Alt > H > B > T | ⌘+⌥+↑ |
| Add Or Remove Bottom Border | Alt > H > B > B | ⌘+⌥+↓ |
| Add Or Remove Right Border | Alt > H > B > R | ⌘+⌥+→ |
| Add Or Remove Left Border | Alt > H > B > L | ⌘+⌥+← |
| Remove Borders | Ctrl+Shift+_ | ⌘+⌥+_ |
| Formatting Shortcuts | yes | |
| Open Format Cells Dialog Box | Ctrl+1 | ⌘+1 |
| Repeat Previous Format | F4 | ⌃+Y |
| Toggle Bold Formatting | Ctrl+B | ⌘+B |
| Toggle Italic Formatting | Ctrl+I | ⌘+I |
| Toggle Underline | Ctrl+U | ⌘+U |
| Toggle Strikethrough | Ctrl+5 | ⌘+⇧+X |
| Apply Superscript Formatting | Ctrl+Shift+F > Alt+E | |
| Apply Subscript Formatting | Ctrl+Shift+F > Alt+B | |
| Wrap Text | Alt > H > W | |
| Merge Cells | Alt > H > M | |
| Align Center | Alt > H > A > C | ⌘+E |
| Align Left | Alt > H > A > L | ⌘+L |
| Align Right | Alt > H > A > R | ⌘+R |
| Indent | Alt > H > 6 | ⌃+⌥ > tab |
| Remove Indent | Alt > H > 5 | ⌃+⌥ > ⇧+tab |
| Increase Font Size | Alt > H > F > G | ⌘+⇧+> |
| Decrease Font Size | Alt > H > F > K | ⌘+⇧+ |
| Apply Conditional Formatting | Alt > H > L | |
| Format Painter | Ctrl+Alt+V | |
| Highlight Cell | Alt > H > H | |
| Fill Color | Alt > H > H | |
| Pivot Table Shortcuts | yes | |
| Open Pivot Table Wizard | Alt > N > V | ⌘+⌥ > P |
| Create Pivot Chart On Same Worksheet | Alt+F1 | |
| Create Pivot Chart On New Worksheet | F11 | F11 |
| Select Entire Pivot Table | Ctrl+A | ⌘+A |
| Group Pivot Table Items | Alt+Shift+→ | ⌘+⇧+K |
| Ungroup Pivot Table Items | Alt+Shift+← | ⌘+⇧+J |
| Hide Pivot Table Item | Ctrl+- | ⌃+- |
| Toggle Pivot Table Field Checkbox | Space | space |
| Entering Data Shortcuts | yes | |
| Enter Text And Move Down | Enter | return |
| Enter Text And Move Right | Tab | tab |
| Enter Text And Move Up | Shift+Enter | ⇧+return |
| Enter Text And Move Left | Shift+Tab | ⇧+tab |
| Complete Entry And Stay In Same Cell | Ctrl+Enter | ⌃+return |
| Enter Same Data In Multiple Cells | Ctrl+Enter | ⌃+return |
| Copy Formula From Cell Above | Ctrl+' | ⌃+' |
| Copy Value From Cell Above | Ctrl+Shift+" | ⌃+⇧+" |
| Add Hyperlink | Ctrl+K | ⌘+K |
| Insert Current Date | Ctrl+; | ⌃+; |
| Insert Current Time | Ctrl+Shift+: | ⌃+⇧+: |
| Display Autocomplete List | Alt+↓ | ⌥+↓ |
| Flash Fill | Ctrl+E | |
| Fill Down | Ctrl+D | ⌃+D |
| Fill Right | Ctrl+R | ⌃+R |
| Navigation Shortcuts | yes | |
| Move One Cell | → | → |
| Move to Edge of Data Region | Ctrl+→ | ⌘+→ |
| Move One Screen Up | PgUp | fn+↑ |
| Move One Screen Down | PgDn | fn+↓ |
| Move One Screen Right | Alt+PgDn | fn+⌥ > ↑ |
| Move One Screen Left | Alt+PgUp | fn+⌥ > ↓ |
| Move To Beginning Of Row | Home | fn+← |
| Move To First Cell In Worksheet | Ctrl+Home | fn+⌃+← |
| Move To Last Used Cell In Worksheet | Ctrl+End | fn+⌃+→ |
| Turn End Mode On | End | fn+→ |
| Creating Formula Shortcuts | yes | |
| Open The Insert Function Dialog Box | Shift+F3 | ⇧+F3 |
| Cycles Through Absolute And Relative References | F4 | ⌘+T |
| Insert Function Arguments into Cell | Ctrl+Shift+A | ⌃+⇧+A |
| Open The Insert Function Dialog Box From Within Cell | Ctrl+A | ⌃+A |
| Sum Selected Cells | Alt+= | ⌘+⇧+T |
| Calculate Part of a Formula | F9 | F9 |
| Create Array Formula | Ctrl+Shift+Enter | ⌃+⇧+return |
| Named Ranged Shortcuts | yes | |
| Open Name Manager Dialog Box | Ctrl+F3 | ⌃+L |
| Insert Named Range Into Formula | F3 | |
| Create Name Based on Row and Column Headings | Ctrl+Shift+F3 | ⌃+⇧+F3 |
| Calculation Shortcuts | yes | |
| Calculate Now | F9 | F9 |
| Calculate Active Sheet | Shift+F9 | ⇧+F9 |
| Force Calculate | Ctrl+Alt+F9 | |
| Manual Calculation | Alt > M > X > M | |
| Turn on Automatic Calculation | Alt > M > X > A | |
| Refresh | F9 | F9 |
| Dialog Box Navigation Shortcuts | yes | |
| Toggle Checkbox | Space | space |
| Apply Changes and Close the Dialog Box | Enter | return |
| Cancel Changes and Close the Dialog Box | Esc | esc |
| Next Control | Tab | tab |
| Previous Control | Shift+Tab | ⇧+tab |
| Next Tab | Ctrl+Tab | ⌃+tab |
| Previous Tab | Ctrl+Shift+Tab | ⌃+⇧+tab |
| Spreadsheet Review Shortcuts | yes | |
| Toggle Formula View Mode | Ctrl+` | ⌃+` |
| trace precedents | Alt > M > P | |
| trace dependents | Alt > M > D | |
| Cell Editing Shortcuts | yes | |
| Edit The Active Cell | F2 | ⌃+U |
| Toggle Between Cell Edit Mode and Cell Enter Mode | F2 | ⌃+U |
| Save Changes and Exit Cell Edit Mode | Enter | |
| Cancel Entry and Exit Cell Edit Mode | Esc | esc |
| Go to Beginning of Cell | Home | fn+← |
| Go to End of Cell | End | fn+→ |
| Select Character | Shift+→ | ⇧+→ |
| Move One Word to Right or Left | Ctrl+→ | ⌥+→ |
| Select One Word to Right or Left | Ctrl+Shift+→ | ⌥+⇧+→ |
| Delete Character to Right of Cursor | Delete | fn+delete |
| Delete Character to the Left of Cursor | Backspace | delete |
| Insert New Line Break Within Cell | Alt+Enter | ⌃+⌥+return |
| Insert Or Edit Comment | Shift+F2 | ⇧+F2 |
| Ribbon Shortcuts | yes | |
| Expand Or Collapse Ribbon | Ctrl+F1 | ⌘+⌥+R |
| Activate Ribbon Shortcut Keys | Alt | ⌃+F2 |
| Move To Next Ribbon Control | Tab | tab |
| Activate Selected Control | Space | space |
| Confirm Control Change | Enter | return |
| Cancel Control Change | Esc | esc |
| Get Help On Selected Control | F1 | |
| Workbook Shortcuts | yes | |
| Insert New Worksheet | Shift+F11 | ⇧+F11 |
| Go To Next Worksheet (Tab) | Ctrl+PgDn | fn+⌃+↓ |
| Go To Previous Worksheet (Tab) | Ctrl+PgUp | fn+⌃+↑ |
| Move To Next Pane | F6 | F6 |
| Move To Previous Pane | Shift+F6 | ⇧+F6 |
| Go To Next Workbook | Ctrl+Tab | ⌃+tab |
| Go To Previous Workbook | Ctrl+Shift+Tab | ⌃+⇧+tab |
| Minimize Current Workbook Window | Ctrl+F9 | ⌘+M |
| Maximize Current Workbook Window | Ctrl+F10 | |
| Switch Tabs | Ctrl+PgUp or PgDn | fn+⌃+↑or↓ |
| Selection Shortcuts | yes | |
| Select Current Region (Possibly Entire Worksheet) | Ctrl+A | ⌘+A |
| Select Visible Cells Only | Alt+; | ⌘+⇧+Z |
| Select Cells With Comments | Ctrl+Shift+O | fn+⌃+⇧+O |
| Display 'Go To' Dialog Box | Ctrl+G | ⌃+G |
| Select Region Directly Around Active Cell | Ctrl+Shift+* | ⇧+⌃+space |
| Select Current Array | Ctrl+/ | ⌃+/ |
| Select Row Differences | Ctrl+\ | ⌃+\ |
| Select Column Differences | Ctrl+Shift+| | ⌃+⇧+| |
| Select All Precedents | Ctrl+Shift+{ | ⌃+⇧+{ |
| Select All Dependents | Ctrl+Shift+} | ⌃+⇧+} |
| Select Direct Precedents | Ctrl+[ | ⌃+[ |
| Select Direct Dependents | Ctrl+] | ⌃+] |
| Misc. Shortcuts | yes | |
| Find | Ctrl+F | ⌘+F |
| Find and Replace | Ctrl+H | ⌃+H |
| Find Previous Match | Ctrl+Shift+F4 | ⌘+fn+F |
| Find Next Match | Shift+F4 | ⌘+F |
| Insert Chart | Alt+F1 | ⌥+F1 |
| Insert Chart in New Worksheet | F11 | F11 |
| Toggle Autofilter | Ctrl+Shift+L | ⌘+⇧+F |
| Activate Filter | Alt+↓ | ⌥+↓ |
| Create Table | Ctrl+T | ⌃+T |
| Open Visual Basic ( VBA ) Editor | Alt+F11 | ⌥+fn+F11 |
| Open Macros | Alt+F8 | ⌥+fn+F8 |
| Stop Running Macro | Ctrl+Pause Break | ⌘+. |
| Worksheet Shortcuts | yes | |
| Insert Row | Ctrl++ | ⌃+I |
| Insert Column | Ctrl++ | ⌃+I |
| Delete Row | Ctrl+- | ⌃+- |
| Delete Column | Ctrl+- | ⌃+- |
| Delete Cell | Ctrl+- | ⌃+- |
| Hide Column | Ctrl+0 | ⌃+0 |
| Hide Row | Ctrl+9 | ⌃+9 |
| Unhide Row | Ctrl+Shift+9 | ⌃+⇧+9 |
| Unhide Column | Ctrl+Shift+0 | ⌃+⇧+0 |
| Display Insert Dialog Box | Ctrl++ | ⌃+I |
| Display Delete Dialog Box | Ctrl+- | ⌃+- |
| Group Rows Or Columns | Alt+Shift+→ | ⌘+⇧+K |
| Ungroup Rows Or Columns | Alt+Shift+← | ⌘+⇧+J |
| Select Entire Row | Shift+Space | ⇧+space |
| Select Entire Column | Ctrl+Space | ⌃+space |
| Select Entire Worksheet | Ctrl+A | ⌘+A |
| Toggle Add To Selection Mode | Shift+F8 | ⇧+F8 |
| Mouse Shortcuts | yes | |
| Zoom In / Zoom Out | Ctrl+Mouse | ⌃+ Mouse |
| Drag And Copy | Ctrl+Drag | ⌥+ Drag |
| Drag And Cut | Drag | Drag |
| Drag And Insert | Shift+ Drag | ⇧+ Drag |
| Drag And Insert Copy | Ctrl+Shift+ Drag | ⌥+⇧+ Drag |
| Drag To Worksheet | Alt+ Drag | ⌘+ Drag |